﻿CREATE TABLE [dbo].[EmployerPhoto] (
    [EmployerId] UNIQUEIDENTIFIER NOT NULL,
    [PhotoId]    INT              NOT NULL,
    [PhotoType]  INT              NULL,
    CONSTRAINT [PK_CompanyPhoto] PRIMARY KEY CLUSTERED ([EmployerId] ASC, [PhotoId] ASC),
    CONSTRAINT [FK_EmployerPhoto_Employer] FOREIGN KEY ([EmployerId]) REFERENCES [dbo].[Employer] ([EmployerId]),
    CONSTRAINT [FK_EmployerPhoto_Photo] FOREIGN KEY ([PhotoId]) REFERENCES [dbo].[Photo] ([PhotoId])
);



